Survey on Intelligent Data Repository Using Soft Computing

Data warehouse is one of the components of the overall business intelligence system. An enterprise has one data warehouse, and data marts source has their information from the data warehouse. The Data warehouse is a corporation of all data marts within the enterprise. Information is always accumulated in the dimensional model. In this paper, an intelligent data repository with soft computing is presented. It covers similarity metrics that are commonly used to improve the efficiency of data storages. It also covers multiple decision making methodologies to improve the efficiency of decision making. This chapter focuses on the review of the literature for Extraction, Transform and Load with Data Warehouse. Moreover the ETL hybridization with fuzzy optimization, Markov Decision model, Decision making criteria and Decision Matrix has also been reviewed. The Decision Matrix is a mathematical tool to deal with uncertainty and vagueness of decision systems. It has been applied successfully in all fields. This paper proposes Hyper ETL with an integration of decision making methodologies and fuzzy optimistic technique.